﻿if exists (select * from dbo.sysobjects where name = 'sp_Departments_Update')	drop procedure [dbo].[sp_Departments_Update]Go CREATE PROCEDURE dbo.sp_Departments_Update	@dpID		int,	@dpCode		nvarchar(50),	@dpName		nvarchar(150),	@dpLevel		nvarchar(100),	@dpOrd		intAS	UPDATE [Departments] SET [dpCode] = @dpCode, [dpName] = @dpName, [dpLevel] = @dpLevel, [dpOrd] = @dpOrd	 WHERE dpID = @dpIDGo 